2013-06-20 - 5768.500 - Spec - Enhance BI Monthly Inventory Extract #InventoryManagement #ABAPEXTRACT

SPECIFICATIONS

5768.500-Enhance BI Monthly Inventory Extract

Purpose

Modify BI Monthly Inventory Extract to get Sales Order Unrestricted quantity in Qty on Hand and Qty On Hand Previous Month

Admin Info

Purpose	Enhance BI Monthly Inventory Extract
Requested By	Ashwin Kucheria
Spec Created By	Venkat Kondapally
Spec Created Date	06/20/2013
Spec QA by	Venkat Kondapally
Objects	ZBI_INVEXT_BI_FM2
Document Status	WIP

References

Prior Tickets

2013-04-23-5768.200-Spec-BI Inventory Extraction Logic

Functional Requirement

The current logic for Quantity on hand in the FM takes the stock from MCHB table. These are batch stocks.
Current logic does not take sales stock into account.
So if there is an open sales order, then the Qty on hand shows negative stock.

So add unrestricted stock from MSKA table in the Qty on hand field based on Material and Plant.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]
Modify Function Module ZBI_INVEXT_BI_FM2 to change the QTY_ON_HAND and QTY_ON_HAND_PREV to reflect sales order Unrestricted stock .

Test Plan

[List test scenarios/cases to be executed here]

	Test Scenario	Expected Results
1	Create SO with Material 10010101 plant 0110	The Qty on hand value should have value from sales order

Solution Details

[Provide complete technical details for configuration or programming here]
Modify Function Module ZBI_INVEXT_BI_FM2 to change the QTY_ON_HAND and QTY_ON_HAND_PREV to reflect sales order Unrestricted stock .

Qty On hand = Total Valuated Stock (MBEW-LBKUM) - blocked stock (MCHB-CSPEM) + Unrestricted Stock ( MSKA-KALAB)
Qty On hand previous period = = Total Valuated Stock (MBEWH-LBKUM) + Unrestricted Stock from (MSKAH-KALAB)